Should integrity constraints be global or local?
نویسنده
چکیده
Data base integrity constraints are commonly expressed as predicates over data base states or state changes (global constraints) or as preconditions of transactions that are to change data base states (local constraints). We argue that business reengineering, and the lack of sophistication of users favor local constraints, but that global constraints may also be necessary. Local constraints are expressed as preconditions of transactions in our specification language SF. Primarily to foster discussion, we extend the concept of integrity by introducing completeness and robustness as two new integrity classes, and define a number of additional discussion topics.
منابع مشابه
Simplification of Integrity Constraints for Data Integration
When two or more databases are combined into a global one, integrity may be violated even when each database is consistent with its own local integrity constraints. Efficient methods for checking global integrity in data integration systems are called for: answers to queries can then be trusted, because either the global database is known to be consistent or suitable actions have been taken to ...
متن کاملOptimistic Concurrency Control for Maintaining the Global Integrity Constraint in MDBSs
The multidatabase system(MDBS) has a global database, a set of global and local transactions, and a global transaction manager(GTM) which is built on top of a number of pre-existing database management systems(DBMS) that are being integrated into a single MDBS. The global transaction manager has the responsibility for maintaining the global consistency of MDBS. It is impossible for LDBSs to pre...
متن کاملOptimistic Global Transaction Management with Preserving the Global Integrity Constraints in MDBS
The objectives of multidatabase transaction management are to avoid the inconsistent retrievals and to preserve the global consistency in the presence of multidatabase updates. In order to maintain the global consistency, the MDBS must ensure the global integrity constraints as well as the global serializability of transactions. The global transaction manager must have the responsibility for gl...
متن کاملEfficient Complete Local Tests for Conjunctive Query Constraints with Negation
We consider the problem of incrementally checking global integrity constraints without using all the relations under constraint. In many application areas such as collaborative design, mobile computing and enterprise information systems, total data availability cannot be assumed. Even if all base data is available, some of it may incur such a high cost that its use should only be considered as ...
متن کاملGlobal Concurrency Control for Maintaining the Inter-Site Constraints in Multidatabase Systems
The global inter-site constraints is to describe the integrity constraints associated with data items in diierent local databases, which specify the global connguration of the data that are considered semantically correct. Locally consistent transactions may generate global inconsistencies with the existence of global integrity constraints. Hence, we need the global transaction manager that ens...
متن کامل